﻿<%@ Page Language="C#" AutoEventWireup="true" CodeFile="IframeStores.aspx.cs" Inherits="IframeStores" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    
        <table style="width:100%;">
            <tr>
                <td>
                    Lenses :</td>
                <td>
                    Boxs :</td>
                <td>
                    &nbsp;</td>
                <td>
                    Solutions :</td>
                <td>
                    &nbsp;</td>
                <td>
                    Accessories :</td>
            </tr>
            <tr>
                <td>
                    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
                        DataSourceID="SqlDataSource1">
                        <Columns>
                            <asp:BoundField DataField="brandname" HeaderText="brandname" 
                                SortExpression="brandname" />
                            <asp:BoundField DataField="vd" HeaderText="vd" SortExpression="vd" />
                            <asp:BoundField DataField="color" HeaderText="color" SortExpression="color" />
                            <asp:BoundField DataField="sph" HeaderText="sph" SortExpression="sph" />
                            <asp:BoundField DataField="cyl" HeaderText="cyl" SortExpression="cyl" />
                            <asp:BoundField DataField="axis" HeaderText="axis" SortExpression="axis" />
                            <asp:BoundField DataField="bc" HeaderText="bc" SortExpression="bc" />
                            <asp:BoundField DataField="diam" HeaderText="diam" SortExpression="diam" />
                            <asp:BoundField DataField="store1" HeaderText="store1" 
                                SortExpression="store1" />
                            <asp:BoundField DataField="store2" HeaderText="store2" 
                                SortExpression="store2" />
                            <asp:BoundField DataField="unitprice" HeaderText="unitprice" 
                                SortExpression="unitprice" />
                            <asp:BoundField DataField="clientprice" HeaderText="clientprice" 
                                SortExpression="clientprice" />
                            <asp:BoundField DataField="doctorprice" HeaderText="doctorprice" 
                                SortExpression="doctorprice" />
                        </Columns>
                    </asp:GridView>
                    <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
                        ConnectionString="<%$ ConnectionStrings:nourcenterConnectionString %>" 
                        
                        SelectCommand="SELECT [brandname], [vd], [color], [sph], [cyl], [axis], [bc], [diam], [store1], [store2], [unitprice], [clientprice], [doctorprice] FROM [lens] ORDER BY [brandname], [vd], [color]">
                    </asp:SqlDataSource>
                </td>
                <td>
                    <asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False" 
                        DataSourceID="SqlDataSource2">
                        <Columns>
                            <asp:BoundField DataField="brandname" HeaderText="brandname" 
                                SortExpression="brandname" />
                            <asp:BoundField DataField="vd" HeaderText="vd" SortExpression="vd" />
                            <asp:BoundField DataField="color" HeaderText="color" SortExpression="color" />
                            <asp:BoundField DataField="pck" HeaderText="pck" SortExpression="pck" />
                            <asp:BoundField DataField="sph" HeaderText="sph" SortExpression="sph" />
                            <asp:BoundField DataField="cyl" HeaderText="cyl" 
                                SortExpression="cyl" />
                            <asp:BoundField DataField="axis" HeaderText="axis" SortExpression="axis" />
                            <asp:BoundField DataField="bc" HeaderText="bc" SortExpression="bc" />
                            <asp:BoundField DataField="diam" HeaderText="diam" SortExpression="diam" />
                            <asp:BoundField DataField="store1" HeaderText="store1" 
                                SortExpression="store1" />
                            <asp:BoundField DataField="store2" HeaderText="store2" 
                                SortExpression="store2" />
                            <asp:BoundField DataField="unitprice" HeaderText="unitprice" 
                                SortExpression="unitprice" />
                            <asp:BoundField DataField="clientprice" HeaderText="clientprice" 
                                SortExpression="clientprice" />
                        </Columns>
                    </asp:GridView>
                    <asp:SqlDataSource ID="SqlDataSource2" runat="server" 
                        ConnectionString="<%$ ConnectionStrings:nourcenterConnectionString %>" 
                        
                        SelectCommand="SELECT [brandname], [vd], [color], [pck], [sph], [bc], [diam], [store1], [store2], [unitprice], [clientprice], [cyl], [axis] FROM [box] ORDER BY [brandname], [vd], [color]">
                    </asp:SqlDataSource>
                </td>
                <td>
                    &nbsp;&nbsp; &nbsp;</td>
                <td>
                    <asp:GridView ID="GridView3" runat="server" AutoGenerateColumns="False" 
                        DataSourceID="SqlDataSource3">
                        <Columns>
                            <asp:BoundField DataField="brandname" HeaderText="brandname" 
                                SortExpression="brandname" />
                            <asp:BoundField DataField="bottlesize" HeaderText="bottlesize" 
                                SortExpression="bottlesize" />
                            <asp:BoundField DataField="store1" HeaderText="store1" 
                                SortExpression="store1" />
                            <asp:BoundField DataField="store2" HeaderText="store2" 
                                SortExpression="store2" />
                            <asp:BoundField DataField="unitprice" HeaderText="unitprice" 
                                SortExpression="unitprice" />
                            <asp:BoundField DataField="clientprice" HeaderText="clientprice" 
                                SortExpression="clientprice" />
                            <asp:BoundField DataField="doctorprice" HeaderText="doctorprice" 
                                SortExpression="doctorprice" />
                        </Columns>
                    </asp:GridView>
                    <asp:SqlDataSource ID="SqlDataSource3" runat="server" 
                        ConnectionString="<%$ ConnectionStrings:nourcenterConnectionString %>" 
                        
                        SelectCommand="SELECT [brandname], [bottlesize], [store1], [store2], [unitprice], [clientprice], [doctorprice] FROM [soln] ORDER BY [brandname], [bottlesize]">
                    </asp:SqlDataSource>
                </td>
                <td>
                    &nbsp;&nbsp; &nbsp;</td>
                <td>
                    <asp:GridView ID="GridView4" runat="server" AutoGenerateColumns="False" 
                        DataSourceID="SqlDataSource4">
                        <Columns>
                            <asp:BoundField DataField="name" HeaderText="name" SortExpression="name" />
                            <asp:BoundField DataField="store1" HeaderText="store1" 
                                SortExpression="store1" />
                            <asp:BoundField DataField="store2" HeaderText="store2" 
                                SortExpression="store2" />
                            <asp:BoundField DataField="unitprice" HeaderText="unitprice" 
                                SortExpression="unitprice" />
                            <asp:BoundField DataField="clientprice" HeaderText="clientprice" 
                                SortExpression="clientprice" />
                            <asp:BoundField DataField="doctorprice" HeaderText="doctorprice" 
                                SortExpression="doctorprice" />
                        </Columns>
                    </asp:GridView>
                    <asp:SqlDataSource ID="SqlDataSource4" runat="server" 
                        ConnectionString="<%$ ConnectionStrings:nourcenterConnectionString %>" 
                        
                        SelectCommand="SELECT [name], [store1], [store2], [unitprice], [clientprice], [doctorprice] FROM [accs] ORDER BY [name]">
                    </asp:SqlDataSource>
                </td>
            </tr>
        </table>
    
    </div>
    </form>
</body>
</html>
